import pymysql

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='root', db='tkq1')
cursor = conn.cursor()
effect_row = cursor.executemany("insert into tk8(id,name,licnese)values(%s,%s,%s)",
                                [([1], ["u3pass"], ["11113"]), ([2], ["u4pass"], ["22224"])])
conn.commit()
cursor.close()
conn.close()